﻿/********************************************************************************************************************
* Author:	Aris Mihail																								*
* Email:	std03055@di.uoa.gr																						*
* Purpose:	This script is used in order to create the stored procedure "usp_category_get_moderators" that			*
*			returns all the moderators of a category																*
********************************************************************************************************************/


CREATE PROCEDURE [dbo].[usp_category_get_moderators]
	@catID bigint
AS

	SELECT	[Category-Moderator].Moderator
	FROM	[Category-Moderator]
	WHERE	[Category-Moderator].Category=@catID

RETURN 0